Choosing items to publish

To select the worksheet or item that you want to publish, select one item from the Choose list. You can publish only one item at a time. To publish another item, select the new item and repeat the publishing procedure. The following list outlines what you can publish and how to publish it.

Entire workbooks Select Entire workbook. You can publish an entire workbook with interactivity in the Publish dialog box, but not without interactivity.
Entire worksheets Select Items on Sheetname, and then select All contents of Sheetname.
Items Select Items on Sheetname, and then select the item you want to publish, such as a PivotTable report or a chart. Items do not include ranges of cells.
Ranges of cells Select Range of cells and then, if the selection box does not contain the range you want, click the worksheet (the dialog box will collapse to a selection box), select a range of cells from the Microsoft Excel workbook, and then click Expand Dialog .
Charts Select Items on Sheetname, and then select Chart x.
Filtered lists Select Items on Sheetname, and then select the AutoFilter item you want to publish.

External data ranges Select Items on Sheetname, and then select the Query item you want to publish.
Republishing To republish a worksheet or item that you have already published, select Previously published items and then select the worksheet or item you want to republish. To prevent an item from being republished, select the item and click Remove. To continue publishing, click another item in the list.